<?php


class Framework_DB_Table_Session extends Framework_DB_Table_Common {

	public $tableName = 'Session';
	
	
	public $sql = array(
		'getData' => array(
			'select' => 'sessData',
			'where'  => 'sessionKey = ?',
			'get'    => 'row'
		)
	);
	
    public function __construct($db) {
   		
    	
    	
   		// Columns
   		$this->col = array(
	   		// Primary Key
	        'ID'  => array(
	           'type'     => 'integer',
	           'require'  => true
	        ),
	      
	        'sessionKey'  => array(
	           'type'     => 'char',
			   'size'     => 32
	        ),
	        
	        'sessData' => array(
	           'type'     => 'clob'
	        ),
	        
	        // Foreign Key
	        'curBrowse'   => array(
	           'type'     => 'integer'
	        ),
	        
	       
			'idSiteUser'  => array(
	           'type'     => 'integer'
	        ),

	        'dateTouched' => array(
	           'type'     => 'integer'
	        )
	        	
	        
	    );
	    
	    $this->auto_inc_col = 'ID';
	    
	    // Indexes
	    $this->idx = array(
	    	'ID'          =>  'primary',
	    	'curBrowse'   =>  'normal',
	    	'idSiteUser'  =>  'normal',
	    );
   		
   		parent::__construct($db);
   }
	
	
}

?>